Show AllSets the specified fill to a preset gradient.
expression.PresetGradient(Style, Variant, PresetGradientType)
expression Required. An expression that returns one of the objects in the Applies To list.
Style Required MsoGradientStyle. The gradient style for the specified fill.
| MsoGradientStyle can be one of these MsoGradientStyle constants. |
| msoGradientDiagonalDown |
| msoGradientDiagonalUp |
| msoGradientFromCenter |
| msoGradientFromCorner |
| msoGradientFromTitle |
| msoGradientHorizontal |
| msoGradientMixed |
| msoGradientVertical |
Variant Required Long. The gradient variant for the specified fill. Can be a value from 1 through 4, corresponding to the four variants listed on the Gradient tab in the Fill Effects dialog box. If Style is msoGradientFromCenter, the Variant argument can only be 1 or 2.
PresetGradientType Required MsoPresetGradientType. The gradient type for the specified fill.
| MsoPresetGradientType can be one of these MsoPresetGradientType constants. |
| msoGradientBrass |
| msoGradientChrome |
| msoGradientDaybreak |
| msoGradientEarlySunset |
| msoGradientFog |
| msoGradientGoldII |
| msoGradientLateSunset |
| msoGradientMoss |
| msoGradientOcean |
| msoGradientPeacock |
| msoGradientRainbowII |
| msoGradientSilver |
| msoGradientWheat |
| msoPresetGradientMixed |
| msoGradientCalmWater |
| msoGradientChromeII |
| msoGradientDesert |
| msoGradientFire |
| msoGradientGold |
| msoGradientHorizon |
| msoGradientMahogany |
| msoGradientNightfall |
| msoGradientParchment |
| msoGradientRainbow |
| msoGradientSapphire |
This example sets the chart's fill format to the preset brass color.
With myChart.ChartArea.Fill
.Visible = True
.PresetGradient msoGradientDiagonalDown, 3, msoGradientBrass
End With